namespace Apps.Models
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("V_PUB_SCHEME")]
    public partial class V_PUB_SCHEME
    {
      
        [Key]
        [Column(Order = 0)]
        [StringLength(40)]
        public string SCHEME_ID { get; set; }

        public DateTime? EFFECTIVE_DATE { get; set; }

        [StringLength(20)]
        public string SCHEME_TYPE { get; set; }

        [StringLength(10)]
        public string SCHEME_TYPE_STR { get; set; }

        public int? LAYOUT_TYPE { get; set; }

        public int? CAR_COUNT { get; set; }

        public decimal? COAL_TOTAL { get; set; }

        public int? POINT_SUM { get; set; }

        public int? POINT_COUNT { get; set; }

        [Key]
        [Column(Order = 1)]
        [StringLength(400)]
        public string SCHEME_MARK { get; set; }

        public int? STATUS { get; set; }

        [Key]
        [Column(Order = 2)]
        [StringLength(40)]
        public string COMPILE_USER { get; set; }

        [Key]
        [Column(Order = 3)]
        public DateTime COMPILE_DATE { get; set; }

        public int? SAMPLE_MACHINE_GROUP { get; set; }

        [StringLength(200)]
        public string SAMPLE_MACHINE_GROUP_STR { get; set; }

        [StringLength(200)]
        public string USERNAME { get; set; }
        public string BATCH_CODE { get; set; }
    }
}